Creating Interviewer Activity - Page 3 of the dashboard 22

Creating Interviewer Activity - Page 3 of the dashboard

Duplicate the KPI Overview page and delete everything except the Interviewer NPS and Interviewer Score KPI cards and rename the page to Interviewer Activity. Then change the name in the text box as Interviewer Activity Dashboard, and move the colaberry logo to top left side and align it as shown in the screenshot below.

Creating Scattered Plot:

Step 1: In Fields

Select the scattered plot icon from the visualization panel.
Select Interviewer from Interviewer Dim table to Details
Select Interviewer Score from the Measure table to X-Axis
Select Interviewer NPS from Measure table to Y-Axis
Select Interviews Per Day from Measure table to Size
Select Year Month from Date table to Play Axis
Select Interviewee from Interviewee Dim table to Tooltips.

Step 2: In Format Tool.

X axis
- Start 1, End 1
- Text size 9
- Font Family - Segoe UI
- Title text size - 12
- Everything else remains the same.
Y axis
- Start 20, End 120
- Everything else same as above (X axis)
Data Color:
- Format by - Field value
- Based on field - InterviewerScattereColor from the Measure table.
Category ON
Title ON and renamed to Interview NPS and Score by Interviewer.
Background ON
- Color - White, and Transparency - 0
Tooltip ON
Visual header ON

Step 3: In Analytics

X-Axis Constant Line 1 click + add
- Value 0.9
- Transparency 50
- Line style - Dashed
- Position - In front
Y-Axis Constant Line 1 click + add
- Value 55
- Everything else same as above (X-Axis)

Step 4: Adding the Rolling 12Months

Select Filters panel.
Drag and drop Rolloing12Month from the Date table to the area that says "Add data fields here" as shown in the screenshot.
On the Filter type, select Basic filtering and select 1

after that go to filter pane click on expand button next to the Interviewer, select basic filtering, click on select all and then uncheck (Blank) as shown in the screenshot to avoid blanks in the report.

When you are done putting all these together, you will have something like this.

When you click on the play axis button you can pause it to see the values in monthly basis also.

Scatter chats and bubble charts in power bi

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter